UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BB2NuUkFZMhm1cCVmFJL5FBuCHlSQn7IEttfVqF5AYo='
WHERE
key_id = 'aaa12c0ad51ff506b7928c4d6990585df52e3e7743cc296ed86957b1a718e5e9'
AND (
token = 'BB2NuUkFZMhm1cCVmFJL5FBuCHlSQn7IEttfVqF5AYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)