UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qA1TxqLkB4+2KYG8jKJE8aBxLbY9TtwDwFfiBVU0RiA='
WHERE
key_id = 'c6c4d533f62e3663eb190dff33c0c15b8ccdfe803b58175fb6e51213d21c50ec'
AND (
token = 'qA1TxqLkB4+2KYG8jKJE8aBxLbY9TtwDwFfiBVU0RiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)