UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3egjVx2GKHC8Tr1VeX1J8XXbFU0oSHYdNDOZOoURWKY='
WHERE
key_id = 'ad3ec034e14b8e5a906d1f539f92c0703df1ea55da2fd94be8781d58344cc4a8'
AND (
token = '3egjVx2GKHC8Tr1VeX1J8XXbFU0oSHYdNDOZOoURWKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)