UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2phL2DClWWn2c3ZuMboZ2nHV8UxpzJKbQh9XqTJz6oE='
WHERE
key_id = '42fed7323b7baaf2ff533826b8fcee0e5b7f1998d4e83327a879f7002ef019c7'
AND (
token = '2phL2DClWWn2c3ZuMboZ2nHV8UxpzJKbQh9XqTJz6oE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)