UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WYW6zOq9tZZMY45aiGLEeTPQjzj+CG5gntiGgivwwY4='
WHERE
key_id = '9e0980fb6a38c3b09eb466787cc76f55184b2fdfbf5d6e1c062e99fbdc75966b'
AND (
token = 'WYW6zOq9tZZMY45aiGLEeTPQjzj+CG5gntiGgivwwY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)