UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNTndVHAvQ0hIO14hjSMMfM+9fLGoJDkliiMFi4aqIM='
WHERE
key_id = 'ca1af356b685b3dcbf6e80abdfd20bacae1e66dd45e01d641cda0b9e82341e45'
AND (
token = 'bNTndVHAvQ0hIO14hjSMMfM+9fLGoJDkliiMFi4aqIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)