UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plKYLoFymfKjEX824sEz07A1vTDGv3T56/WS+Fqz8jk='
WHERE
key_id = 'a9ca917385b66bef715dfd6c38fdcc04b9d7d1f218fe4f052f4f606a840e4cde'
AND (
token = 'plKYLoFymfKjEX824sEz07A1vTDGv3T56/WS+Fqz8jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)