UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0uHI3yeCOgZxDUUmTkS9+En+MQIfgorNLEzGiAlmpwY='
WHERE
key_id = '123db4cde81133a32284bec67371a4d4c43a17a7712e15f501340b89bf9bb644'
AND (
token = '0uHI3yeCOgZxDUUmTkS9+En+MQIfgorNLEzGiAlmpwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)