UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eKENLIEG9Sc5/A+Dh0rJm4sZDyVjChp/SJ257ro1VwA='
WHERE
key_id = 'b278ab90d36d144bdbf07821c39a2696f03f8af86e777171e536fcfc6dfb82ed'
AND (
token = 'eKENLIEG9Sc5/A+Dh0rJm4sZDyVjChp/SJ257ro1VwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)