UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gLtTG9bML80rUWlxU8yk6Ennh7rjCHCSEhmCq82N1A='
WHERE
key_id = '6e729e7f246e14ce7ab3f6e3b15b1594266c7f3c8c3e884974e72d3bd5a66206'
AND (
token = '1gLtTG9bML80rUWlxU8yk6Ennh7rjCHCSEhmCq82N1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)