UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qfvtSz4rME+dpG8psX3HGhWy2sN3T45VtHKbF0KRofc='
WHERE
key_id = 'bf4e6c15d40b02c94cfc66b5a86a3baadebb327c4cb939d85792969edc412f7c'
AND (
token = 'qfvtSz4rME+dpG8psX3HGhWy2sN3T45VtHKbF0KRofc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)