UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9eW0ECTPNjQNXJf3/uquLQtVBfvZbJCi8h44JmKqc8='
WHERE
key_id = '54b3d9b74e0e6c43df43c736a600be14dacb8ea2332848bdc7f5bf090525a463'
AND (
token = 'z9eW0ECTPNjQNXJf3/uquLQtVBfvZbJCi8h44JmKqc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)