UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/M9h9dZ4vcgwBfnaEtvhFEBDd5gmLm10+IJmJr0HYog='
WHERE
key_id = 'f43d7a3c960dfefec278ca10998eb858ad59ba942eace4c3b6af5d838008736b'
AND (
token = '/M9h9dZ4vcgwBfnaEtvhFEBDd5gmLm10+IJmJr0HYog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)