UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LEu5XcNwN07F7eEUDzig3wu1gmhpNVAJi3qf7k6T53I='
WHERE
key_id = 'd27cc34a27bb32f440d9e170786a3e8f2002df7566bea859bfb49a8071ffc049'
AND (
token = 'LEu5XcNwN07F7eEUDzig3wu1gmhpNVAJi3qf7k6T53I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)