UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHcYV7lzEA4XIHDqv4s24PZAbMtS9uhr+KQX97E1ML8='
WHERE
key_id = '8a0c40b7d86768c2f6c9496d527fc821c51933ef35a359e8d4d20a4326fe3f39'
AND (
token = 'fHcYV7lzEA4XIHDqv4s24PZAbMtS9uhr+KQX97E1ML8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)