UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WvId3RiBOx+nXNi1SJtZmXq6luXcCvmch6GsIH91Ok='
WHERE
key_id = '78e947cf0b82d489989c09bb7514f936bca2cdeb997e907f3dc71f6d00821597'
AND (
token = '/WvId3RiBOx+nXNi1SJtZmXq6luXcCvmch6GsIH91Ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)