UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTfjvE5uh4uFKL7OdyN1ykfVa/DVKNpGpksb9x/p8Rw='
WHERE
key_id = 'c544845df8a11532495812f9ad77c413a876ab97dbb11cb621f4d039d6bd41b1'
AND (
token = 'bTfjvE5uh4uFKL7OdyN1ykfVa/DVKNpGpksb9x/p8Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)