UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jZOy7TTQBrtW302E9HM8ixFD98WZPucv5gWUk8AV9e8='
WHERE
key_id = '2892558a71a10973199987cb206e7c419d3860e4b6864a0acd17a4d0abdc6fcc'
AND (
token = 'jZOy7TTQBrtW302E9HM8ixFD98WZPucv5gWUk8AV9e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)