UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UgqpDlQCtr9FaaHvKOc5ABA5UycXWJolVt0D2nXnQ0='
WHERE
key_id = 'b04f799b51249f543ece1255bfd94cd26f029e6c63a473ecae23ef5cef727fc2'
AND (
token = '7UgqpDlQCtr9FaaHvKOc5ABA5UycXWJolVt0D2nXnQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)