UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TcWOO/47hTEpBOiExrz8yynVuJBBwiBGsX/uNcGUXM='
WHERE
key_id = 'ed8f2450e1234fd769681337641fa17170efd99004f9c516944952fc5c5b0484'
AND (
token = '6TcWOO/47hTEpBOiExrz8yynVuJBBwiBGsX/uNcGUXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)