UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COlhi4QZookA919o59e4Ommg/wj7J2lm/X4RepGHOWc='
WHERE
key_id = 'dd9aab86888380d268913e7c7a2397004a084c7dcc3f0255f60b66c047519c25'
AND (
token = 'COlhi4QZookA919o59e4Ommg/wj7J2lm/X4RepGHOWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)