UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0k/TqZBQhT9YqqmLL5/xEyz4oA7m6FAKavHvDN9i27I='
WHERE
key_id = '9eb202a7e490a899a2b29c05e7b1529e8043a3249dcfd52faa61bb91d0b32285'
AND (
token = '0k/TqZBQhT9YqqmLL5/xEyz4oA7m6FAKavHvDN9i27I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)