UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ysjNbJVRr7wUz9MffMhEVyhn0QV5yrSucGwoTsgF6LU='
WHERE
key_id = '41e9feb2d47ab245e1664792e73f829fb97729d39d1c4d5ae6e8eede621d23ed'
AND (
token = 'ysjNbJVRr7wUz9MffMhEVyhn0QV5yrSucGwoTsgF6LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)