UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YRBqo/B/mqpFoqxsGK/6430jbZ9Y42gAtS6Vk1s7Zfw='
WHERE
key_id = 'dac20b862b043a591ef115862e49018914c5e376737c616b2239c27f873a41f9'
AND (
token = 'YRBqo/B/mqpFoqxsGK/6430jbZ9Y42gAtS6Vk1s7Zfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)