UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnL9y9QLQzHPU0xatGjI67PVc5vaS/fRGHk7cnV3+DA='
WHERE
key_id = 'bab2b839a0d9c465faaa78b727e83dcdcb75468af171b73f61238ee000eaeaca'
AND (
token = 'NnL9y9QLQzHPU0xatGjI67PVc5vaS/fRGHk7cnV3+DA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)