UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mZ8xaNHOgalejfG+JVGefoEofsc35D0w2JcQdelqLSA='
WHERE
key_id = 'b569f80cb3856d9a4767e495cd831c81a6f0fb83f974de9c10a2d3ae5ee7935a'
AND (
token = 'mZ8xaNHOgalejfG+JVGefoEofsc35D0w2JcQdelqLSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)