UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHK9kNuuU4L8gHWNVetBHqoAxmNU17h+orlpFi6KXrY='
WHERE
key_id = '28a5a48e78882bf1fb8e4d9b39d730e3112df735b9544f55de12c2a4a99ff396'
AND (
token = 'hHK9kNuuU4L8gHWNVetBHqoAxmNU17h+orlpFi6KXrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)